Profiling Report

Dataset statistics

Number of variables	21
Number of observations	3376
Missing cells	13129
Missing cells (%)	18.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	554.0 KiB
Average record size in memory	168.0 B

Variable types

Categorical	6
Numeric	13
Text	2

Alerts

`NumberofBuildings` is highly overall correlated with `ThirdLargestPropertyUseType`	High correlation
`PropertyGFATotal` is highly overall correlated with `PropertyGFABuilding(s)` and 3 other fields	High correlation
`PropertyGFABuilding(s)` is highly overall correlated with `PropertyGFATotal` and 3 other fields	High correlation
`LargestPropertyUseTypeGFA` is highly overall correlated with `PropertyGFATotal` and 3 other fields	High correlation
`SecondLargestPropertyUseTypeGFA` is highly overall correlated with `PropertyGFATotal` and 3 other fields	High correlation
`ThirdLargestPropertyUseTypeGFA` is highly overall correlated with `SecondLargestPropertyUseTypeGFA`	High correlation
`TotalGHGEmissions` is highly overall correlated with `PropertyGFATotal` and 3 other fields	High correlation
`GHGEmissionsIntensity` is highly overall correlated with `TotalGHGEmissions`	High correlation
`BuildingType` is highly overall correlated with `PrimaryPropertyType`	High correlation
`PrimaryPropertyType` is highly overall correlated with `BuildingType`	High correlation
`ThirdLargestPropertyUseType` is highly overall correlated with `NumberofBuildings`	High correlation
`SecondLargestPropertyUseType` is highly imbalanced (55.5%)	Imbalance
`ComplianceStatus` is highly imbalanced (83.1%)	Imbalance
`SecondLargestPropertyUseType` has 1697 (50.3%) missing values	Missing
`SecondLargestPropertyUseTypeGFA` has 1697 (50.3%) missing values	Missing
`ThirdLargestPropertyUseType` has 2780 (82.3%) missing values	Missing
`ThirdLargestPropertyUseTypeGFA` has 2780 (82.3%) missing values	Missing
`YearsENERGYSTARCertified` has 3257 (96.5%) missing values	Missing
`ENERGYSTARScore` has 843 (25.0%) missing values	Missing
`NumberofBuildings` is highly skewed (γ1 = 43.39499472)	Skewed
`PropertyGFATotal` is highly skewed (γ1 = 24.12940742)	Skewed
`PropertyGFABuilding(s)` is highly skewed (γ1 = 27.62439064)	Skewed
`LargestPropertyUseTypeGFA` is highly skewed (γ1 = 30.09595071)	Skewed
`NumberofBuildings` has 92 (2.7%) zeros	Zeros
`PropertyGFAParking` has 2872 (85.1%) zeros	Zeros
`SecondLargestPropertyUseTypeGFA` has 126 (3.7%) zeros	Zeros
`ThirdLargestPropertyUseTypeGFA` has 48 (1.4%) zeros	Zeros

Reproduction

Analysis started	2023-06-12 08:18:43.813797
Analysis finished	2023-06-12 08:20:34.920086
Duration	1 minute and 51.11 seconds
Software version	ydata-profiling vv4.2.0
Download configuration	config.json

BuildingType
Categorical

Distinct	8
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	26.5 KiB

nonresidential	1460
multifamily lr (1-4)	1018
multifamily mr (5-9)	580
multifamily hr (10+)	110
sps-district k-12	98
Other values (3)	110

Length

Max length	20
Median length	20
Mean length	17.167358
Min length	6

Characters and Unicode

Total characters	57957
Distinct characters	30
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	nonresidential
2nd row	nonresidential
3rd row	nonresidential
4th row	nonresidential
5th row	nonresidential

Common Values

Value	Count	Frequency (%)
nonresidential	1460	43.2%
multifamily lr (1-4)	1018	30.2%
multifamily mr (5-9)	580	17.2%
multifamily hr (10+)	110	3.3%
sps-district k-12	98	2.9%
nonresidential cos	85	2.5%
campus	24	0.7%
nonresidential wa	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
multifamily	1708	24.5%
nonresidential	1546	22.2%
lr	1018	14.6%
1-4	1018	14.6%
mr	580	8.3%
5-9	580	8.3%
hr	110	1.6%
10	110	1.6%
sps-district	98	1.4%
k-12	98	1.4%
Other values (3)	110	1.6%

Most occurring characters

Value	Count	Frequency (%)
i	6704	11.6%
l	5980	10.3%
n	4638	8.0%
m	4020	6.9%
	3600	6.2%
t	3450	6.0%
r	3352	5.8%
a	3279	5.7%
e	3092	5.3%
s	1949	3.4%
Other values (20)	17893	30.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	45425	78.4%
Decimal Number	3612	6.2%
Space Separator	3600	6.2%
Dash Punctuation	1794	3.1%
Close Punctuation	1708	2.9%
Open Punctuation	1708	2.9%
Math Symbol	110	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	6704	14.8%
l	5980	13.2%
n	4638	10.2%
m	4020	8.8%
t	3450	7.6%
r	3352	7.4%
a	3279	7.2%
e	3092	6.8%
s	1949	4.3%
u	1732	3.8%
Other values (9)	7229	15.9%

Decimal Number

Value	Count	Frequency (%)
1	1226	33.9%
4	1018	28.2%
5	580	16.1%
9	580	16.1%
0	110	3.0%
2	98	2.7%

Space Separator

Value	Count	Frequency (%)
	3600	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1794	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1708	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1708	100.0%

Math Symbol

Value	Count	Frequency (%)
+	110	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	45425	78.4%
Common	12532	21.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	6704	14.8%
l	5980	13.2%
n	4638	10.2%
m	4020	8.8%
t	3450	7.6%
r	3352	7.4%
a	3279	7.2%
e	3092	6.8%
s	1949	4.3%
u	1732	3.8%
Other values (9)	7229	15.9%

Common

Value	Count	Frequency (%)
	3600	28.7%
-	1794	14.3%
)	1708	13.6%
(	1708	13.6%
1	1226	9.8%
4	1018	8.1%
5	580	4.6%
9	580	4.6%
0	110	0.9%
+	110	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	57957	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	6704	11.6%
l	5980	10.3%
n	4638	8.0%
m	4020	6.9%
	3600	6.2%
t	3450	6.0%
r	3352	5.8%
a	3279	5.7%
e	3092	5.3%
s	1949	3.4%
Other values (20)	17893	30.9%

PrimaryPropertyType
Categorical

Distinct	24
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	26.5 KiB

low-rise multifamily	987
mid-rise multifamily	564
small- and mid-sized office	293
other	256
warehouse	187
Other values (19)	1089

Length

Max length	27
Median length	22
Mean length	17.189277
Min length	5

Characters and Unicode

Total characters	58031
Distinct characters	29
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	hotel
2nd row	hotel
3rd row	hotel
4th row	hotel
5th row	hotel

Common Values

Value	Count	Frequency (%)
low-rise multifamily	987	29.2%
mid-rise multifamily	564	16.7%
small- and mid-sized office	293	8.7%
other	256	7.6%
warehouse	187	5.5%
large office	173	5.1%
k-12 school	139	4.1%
mixed use property	133	3.9%
high-rise multifamily	105	3.1%
retail store	91	2.7%
Other values (14)	448	13.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
multifamily	1656	23.6%
low-rise	987	14.1%
mid-rise	564	8.0%
office	508	7.2%
small	293	4.2%
and	293	4.2%
mid-sized	293	4.2%
other	256	3.6%
warehouse	199	2.8%
large	173	2.5%
Other values (28)	1794	25.6%

Most occurring characters

Value	Count	Frequency (%)
i	7607	13.1%
l	5597	9.6%
m	4764	8.2%
e	4535	7.8%
	3640	6.3%
r	3355	5.8%
s	3179	5.5%
a	3045	5.2%
o	2881	5.0%
f	2811	4.8%
Other values (19)	16617	28.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	51664	89.0%
Space Separator	3640	6.3%
Dash Punctuation	2409	4.2%
Decimal Number	278	0.5%
Other Punctuation	40	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	7607	14.7%
l	5597	10.8%
m	4764	9.2%
e	4535	8.8%
r	3355	6.5%
s	3179	6.2%
a	3045	5.9%
o	2881	5.6%
f	2811	5.4%
t	2796	5.4%
Other values (14)	11094	21.5%

Decimal Number

Value	Count	Frequency (%)
1	139	50.0%
2	139	50.0%

Space Separator

Value	Count	Frequency (%)
	3640	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2409	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	40	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	51664	89.0%
Common	6367	11.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	7607	14.7%
l	5597	10.8%
m	4764	9.2%
e	4535	8.8%
r	3355	6.5%
s	3179	6.2%
a	3045	5.9%
o	2881	5.6%
f	2811	5.4%
t	2796	5.4%
Other values (14)	11094	21.5%

Common

Value	Count	Frequency (%)
	3640	57.2%
-	2409	37.8%
1	139	2.2%
2	139	2.2%
/	40	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	58031	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	7607	13.1%
l	5597	9.6%
m	4764	8.2%
e	4535	7.8%
	3640	6.3%
r	3355	5.8%
s	3179	5.5%
a	3045	5.2%
o	2881	5.0%
f	2811	4.8%
Other values (19)	16617	28.6%

Neighborhood
Categorical

Distinct	14
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	26.5 KiB

downtown	573
east	453
magnolia / queen anne	423
greater duwamish	375
northeast	280
Other values (9)	1272

Length

Max length	22
Median length	16
Mean length	10.11404
Min length	4

Characters and Unicode

Total characters	34145
Distinct characters	21
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	downtown
2nd row	downtown
3rd row	downtown
4th row	downtown
5th row	downtown

Common Values

Value	Count	Frequency (%)
downtown	573	17.0%
east	453	13.4%
magnolia / queen anne	423	12.5%
greater duwamish	375	11.1%
northeast	280	8.3%
lake union	251	7.4%
northwest	221	6.5%
north	187	5.5%
southwest	166	4.9%
central	134	4.0%
Other values (4)	313	9.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
downtown	573	10.9%
east	453	8.6%
magnolia	423	8.0%
	423	8.0%
queen	423	8.0%
anne	423	8.0%
greater	375	7.1%
duwamish	375	7.1%
northeast	280	5.3%
union	251	4.8%
Other values (9)	1273	24.1%

Most occurring characters

Value	Count	Frequency (%)
n	4163	12.2%
e	3790	11.1%
a	3498	10.2%
t	3246	9.5%
o	2772	8.1%
w	1908	5.6%
	1896	5.6%
s	1852	5.4%
r	1791	5.2%
h	1326	3.9%
Other values (11)	7903	23.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	31826	93.2%
Space Separator	1896	5.6%
Other Punctuation	423	1.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	4163	13.1%
e	3790	11.9%
a	3498	11.0%
t	3246	10.2%
o	2772	8.7%
w	1908	6.0%
s	1852	5.8%
r	1791	5.6%
h	1326	4.2%
u	1310	4.1%
Other values (9)	6170	19.4%

Space Separator

Value	Count	Frequency (%)
	1896	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	423	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	31826	93.2%
Common	2319	6.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	4163	13.1%
e	3790	11.9%
a	3498	11.0%
t	3246	10.2%
o	2772	8.7%
w	1908	6.0%
s	1852	5.8%
r	1791	5.6%
h	1326	4.2%
u	1310	4.1%
Other values (9)	6170	19.4%

Common

Value	Count	Frequency (%)
	1896	81.8%
/	423	18.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	34145	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	4163	12.2%
e	3790	11.1%
a	3498	10.2%
t	3246	9.5%
o	2772	8.1%
w	1908	5.6%
	1896	5.6%
s	1852	5.4%
r	1791	5.2%
h	1326	3.9%
Other values (11)	7903	23.1%

YearBuilt
Real number (ℝ)

Distinct	113
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1968.5732

Minimum	1900
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	1900
5-th percentile	1908
Q1	1948
median	1975
Q3	1997
95-th percentile	2012
Maximum	2015
Range	115
Interquartile range (IQR)	49

Descriptive statistics

Standard deviation	33.088156
Coefficient of variation (CV)	0.016808192
Kurtosis	-0.87134177
Mean	1968.5732
Median Absolute Deviation (MAD)	24
Skewness	-0.53944456
Sum	6645903
Variance	1094.8261
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2000	72	2.1%
2014	67	2.0%
1989	67	2.0%
2008	66	2.0%
1988	64	1.9%
1999	64	1.9%
1968	63	1.9%
1990	60	1.8%
2001	60	1.8%
2002	59	1.7%
Other values (103)	2734	81.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1900	55	1.6%
1901	8	0.2%
1902	11	0.3%
1903	4	0.1%
1904	15	0.4%
1905	9	0.3%
1906	19	0.6%
1907	31	0.9%
1908	27	0.8%
1909	32	0.9%

Value	Count	Frequency (%)
2015	37	1.1%
2014	67	2.0%
2013	51	1.5%
2012	35	1.0%
2011	15	0.4%
2010	24	0.7%
2009	41	1.2%
2008	66	2.0%
2007	42	1.2%
2006	45	1.3%

NumberofBuildings
Real number (ℝ)

HIGH CORRELATION SKEWED ZEROS

Distinct	17
Distinct (%)	0.5%
Missing	8
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	1.1068884

Minimum	0
Maximum	111
Zeros	92
Zeros (%)	2.7%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	111
Range	111
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.1084018
Coefficient of variation (CV)	1.9048007
Kurtosis	2205.2962
Mean	1.1068884
Median Absolute Deviation (MAD)	0
Skewness	43.394995
Sum	3728
Variance	4.4453579
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
1	3175	94.0%
0	92	2.7%
2	37	1.1%
3	22	0.7%
4	12	0.4%
5	10	0.3%
6	5	0.1%
8	3	0.1%
10	2	0.1%
9	2	0.1%
Other values (7)	8	0.2%
(Missing)	8	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	92	2.7%
1	3175	94.0%
2	37	1.1%
3	22	0.7%
4	12	0.4%
5	10	0.3%
6	5	0.1%
7	1	< 0.1%
8	3	0.1%
9	2	0.1%

Value	Count	Frequency (%)
111	1	< 0.1%
27	1	< 0.1%
23	1	< 0.1%
16	1	< 0.1%
14	2	0.1%
11	1	< 0.1%
10	2	0.1%
9	2	0.1%
8	3	0.1%
7	1	< 0.1%

NumberofFloors
Real number (ℝ)

Distinct	50
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.7091232

Minimum	0
Maximum	99
Zeros	16
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	4
Q3	5
95-th percentile	12
Maximum	99
Range	99
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	5.4944648
Coefficient of variation (CV)	1.1667702
Kurtosis	55.950645
Mean	4.7091232
Median Absolute Deviation (MAD)	2
Skewness	5.9223397
Sum	15898
Variance	30.189143
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	692	20.5%
3	692	20.5%
1	466	13.8%
2	439	13.0%
6	306	9.1%
5	295	8.7%
7	148	4.4%
8	64	1.9%
10	32	0.9%
11	32	0.9%
Other values (40)	210	6.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	16	0.5%
1	466	13.8%
2	439	13.0%
3	692	20.5%
4	692	20.5%
5	295	8.7%
6	306	9.1%
7	148	4.4%
8	64	1.9%
9	18	0.5%

Value	Count	Frequency (%)
99	1	< 0.1%
76	1	< 0.1%
63	1	< 0.1%
56	1	< 0.1%
55	1	< 0.1%
49	1	< 0.1%
47	1	< 0.1%
46	1	< 0.1%
42	6	0.2%
41	3	0.1%

PropertyGFATotal
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	3195
Distinct (%)	94.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	94833.537

Minimum	11285
Maximum	9320156
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	11285
5-th percentile	21291.5
Q1	28487
median	44175
Q3	90992
95-th percentile	320096
Maximum	9320156
Range	9308871
Interquartile range (IQR)	62505

Descriptive statistics

Standard deviation	218837.61
Coefficient of variation (CV)	2.3075972
Kurtosis	946.23949
Mean	94833.537
Median Absolute Deviation (MAD)	19739.5
Skewness	24.129407
Sum	3.2015802 × 10⁸
Variance	4.7889898 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
36000	9	0.3%
25920	8	0.2%
28800	7	0.2%
21600	7	0.2%
24000	6	0.2%
22320	4	0.1%
30720	4	0.1%
30240	4	0.1%
43380	3	0.1%
31900	3	0.1%
Other values (3185)	3321	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11285	1	< 0.1%
11685	1	< 0.1%
11968	1	< 0.1%
12294	1	< 0.1%
12769	1	< 0.1%
13157	1	< 0.1%
13661	1	< 0.1%
14101	1	< 0.1%
15398	1	< 0.1%
16000	1	< 0.1%

Value	Count	Frequency (%)
9320156	1	< 0.1%
2200000	1	< 0.1%
1952220	1	< 0.1%
1765970	1	< 0.1%
1605578	1	< 0.1%
1592914	1	< 0.1%
1585960	1	< 0.1%
1536606	1	< 0.1%
1400000	2	0.1%
1380959	1	< 0.1%

PropertyGFAParking
Real number (ℝ)

Distinct	496
Distinct (%)	14.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8001.5261

Minimum	0
Maximum	512608
Zeros	2872
Zeros (%)	85.1%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	46400.75
Maximum	512608
Range	512608
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	32326.724
Coefficient of variation (CV)	4.0400698
Kurtosis	58.974892
Mean	8001.5261
Median Absolute Deviation (MAD)	0
Skewness	6.6511908
Sum	27013152
Variance	1.0450171 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2872	85.1%
13320	3	0.1%
10800	2	0.1%
20416	2	0.1%
30000	2	0.1%
22000	2	0.1%
100176	2	0.1%
25800	2	0.1%
12960	2	0.1%
756	1	< 0.1%
Other values (486)	486	14.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2872	85.1%
38	1	< 0.1%
260	1	< 0.1%
415	1	< 0.1%
604	1	< 0.1%
756	1	< 0.1%
800	1	< 0.1%
919	1	< 0.1%
1263	1	< 0.1%
1392	1	< 0.1%

Value	Count	Frequency (%)
512608	1	< 0.1%
407795	1	< 0.1%
389860	1	< 0.1%
368980	1	< 0.1%
335109	1	< 0.1%
327680	1	< 0.1%
319400	1	< 0.1%
303707	1	< 0.1%
285688	1	< 0.1%
285000	1	< 0.1%

PropertyGFABuilding(s)
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	3193
Distinct (%)	94.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	86832.011

Minimum	3636
Maximum	9320156
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	3636
5-th percentile	21021
Q1	27756
median	43216
Q3	84276.25
95-th percentile	282658.5
Maximum	9320156
Range	9316520
Interquartile range (IQR)	56520.25

Descriptive statistics

Standard deviation	207939.81
Coefficient of variation (CV)	2.3947368
Kurtosis	1161.3603
Mean	86832.011
Median Absolute Deviation (MAD)	18958.5
Skewness	27.624391
Sum	2.9314487 × 10⁸
Variance	4.3238965 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
36000	9	0.3%
25920	8	0.2%
21600	7	0.2%
28800	7	0.2%
24000	6	0.2%
30240	4	0.1%
22320	4	0.1%
30720	4	0.1%
25800	3	0.1%
31900	3	0.1%
Other values (3183)	3321	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3636	1	< 0.1%
10925	1	< 0.1%
11285	1	< 0.1%
11440	1	< 0.1%
11685	1	< 0.1%
11968	1	< 0.1%
12294	1	< 0.1%
12769	1	< 0.1%
12806	1	< 0.1%
13157	1	< 0.1%

Value	Count	Frequency (%)
9320156	1	< 0.1%
2200000	1	< 0.1%
1765970	1	< 0.1%
1632820	1	< 0.1%
1592914	1	< 0.1%
1400000	1	< 0.1%
1380959	1	< 0.1%
1323055	1	< 0.1%
1258280	1	< 0.1%
1215718	1	< 0.1%

ListOfAllPropertyUseTypes
Text

Distinct	466
Distinct (%)	13.8%
Missing	9
Missing (%)	0.3%
Memory size	26.5 KiB

Length

Max length	255
Median length	162
Mean length	25.934363
Min length	5

Characters and Unicode

Total characters	87321
Distinct characters	31
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	314 ?
Unique (%)	9.3%

Sample

1st row	hotel
2nd row	hotel, parking, restaurant
3rd row	hotel
4th row	hotel
5th row	hotel, parking, swimming pool

Value	Count	Frequency (%)
multifamily	1707	17.2%
housing	1707	17.2%
parking	1087	11.0%
office	958	9.7%
store	472	4.8%
other	419	4.2%
retail	404	4.1%
warehouse	278	2.8%
non-refrigerated	261	2.6%
	181	1.8%
Other values (97)	2430	24.5%

Most occurring characters

Value	Count	Frequency (%)
i	9379	10.7%
	6537	7.5%
e	5738	6.6%
o	5413	6.2%
a	5307	6.1%
r	5210	6.0%
l	5017	5.7%
t	4958	5.7%
n	4445	5.1%
u	4299	4.9%
Other values (21)	31018	35.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	76720	87.9%
Space Separator	6537	7.5%
Other Punctuation	3059	3.5%
Dash Punctuation	633	0.7%
Decimal Number	294	0.3%
Open Punctuation	39	< 0.1%
Close Punctuation	39	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	9379	12.2%
e	5738	7.5%
o	5413	7.1%
a	5307	6.9%
r	5210	6.8%
l	5017	6.5%
t	4958	6.5%
n	4445	5.8%
u	4299	5.6%
f	4191	5.5%
Other values (12)	22763	29.7%

Other Punctuation

Value	Count	Frequency (%)
,	2683	87.7%
/	364	11.9%
&	12	0.4%

Decimal Number

Value	Count	Frequency (%)
1	147	50.0%
2	147	50.0%

Space Separator

Value	Count	Frequency (%)
	6537	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	633	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	39	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	39	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	76720	87.9%
Common	10601	12.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	9379	12.2%
e	5738	7.5%
o	5413	7.1%
a	5307	6.9%
r	5210	6.8%
l	5017	6.5%
t	4958	6.5%
n	4445	5.8%
u	4299	5.6%
f	4191	5.5%
Other values (12)	22763	29.7%

Common

Value	Count	Frequency (%)
	6537	61.7%
,	2683	25.3%
-	633	6.0%
/	364	3.4%
1	147	1.4%
2	147	1.4%
(	39	0.4%
)	39	0.4%
&	12	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	87321	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	9379	10.7%
	6537	7.5%
e	5738	6.6%
o	5413	6.2%
a	5307	6.1%
r	5210	6.0%
l	5017	5.7%
t	4958	5.7%
n	4445	5.1%
u	4299	4.9%
Other values (21)	31018	35.5%

LargestPropertyUseType
Text

Distinct	56
Distinct (%)	1.7%
Missing	20
Missing (%)	0.6%
Memory size	26.5 KiB

Length

Max length	52
Median length	19
Mean length	16.255959
Min length	5

Characters and Unicode

Total characters	54555
Distinct characters	31
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	0.3%

Sample

1st row	hotel
2nd row	hotel
3rd row	hotel
4th row	hotel
5th row	hotel

Value	Count	Frequency (%)
multifamily	1667	27.1%
housing	1667	27.1%
office	543	8.8%
warehouse	211	3.4%
non-refrigerated	199	3.2%
other	179	2.9%
store	140	2.3%
k-12	139	2.3%
school	139	2.3%
facility	100	1.6%
Other values (79)	1168	19.0%

Most occurring characters

Value	Count	Frequency (%)
i	6836	12.5%
l	4161	7.6%
u	3825	7.0%
o	3805	7.0%
m	3642	6.7%
f	3116	5.7%
t	3096	5.7%
e	3058	5.6%
a	2831	5.2%
	2796	5.1%
Other values (21)	17389	31.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	50806	93.1%
Space Separator	2796	5.1%
Dash Punctuation	445	0.8%
Decimal Number	278	0.5%
Other Punctuation	196	0.4%
Open Punctuation	17	< 0.1%
Close Punctuation	17	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	6836	13.5%
l	4161	8.2%
u	3825	7.5%
o	3805	7.5%
m	3642	7.2%
f	3116	6.1%
t	3096	6.1%
e	3058	6.0%
a	2831	5.6%
s	2666	5.2%
Other values (12)	13770	27.1%

Other Punctuation

Value	Count	Frequency (%)
/	166	84.7%
,	20	10.2%
&	10	5.1%

Decimal Number

Value	Count	Frequency (%)
1	139	50.0%
2	139	50.0%

Space Separator

Value	Count	Frequency (%)
	2796	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	445	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	17	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	17	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	50806	93.1%
Common	3749	6.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	6836	13.5%
l	4161	8.2%
u	3825	7.5%
o	3805	7.5%
m	3642	7.2%
f	3116	6.1%
t	3096	6.1%
e	3058	6.0%
a	2831	5.6%
s	2666	5.2%
Other values (12)	13770	27.1%

Common

Value	Count	Frequency (%)
	2796	74.6%
-	445	11.9%
/	166	4.4%
1	139	3.7%
2	139	3.7%
,	20	0.5%
(	17	0.5%
)	17	0.5%
&	10	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	54555	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	6836	12.5%
l	4161	7.6%
u	3825	7.0%
o	3805	7.0%
m	3642	6.7%
f	3116	5.7%
t	3096	5.7%
e	3058	5.6%
a	2831	5.2%
	2796	5.1%
Other values (21)	17389	31.9%

LargestPropertyUseTypeGFA
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	3122
Distinct (%)	93.0%
Missing	20
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	79177.639

Minimum	5656
Maximum	9320156
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	5656
5-th percentile	17609
Q1	25094.75
median	39894
Q3	76200.25
95-th percentile	243388.5
Maximum	9320156
Range	9314500
Interquartile range (IQR)	51105.5

Descriptive statistics

Standard deviation	201703.41
Coefficient of variation (CV)	2.5474795
Kurtosis	1320.6098
Mean	79177.639
Median Absolute Deviation (MAD)	17574
Skewness	30.095951
Sum	2.6572016 × 10⁸
Variance	4.0684265 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22000	9	0.3%
24000	9	0.3%
30000	8	0.2%
21600	8	0.2%
20000	7	0.2%
25000	6	0.2%
28800	5	0.1%
45000	5	0.1%
36000	5	0.1%
15000	5	0.1%
Other values (3112)	3289	97.4%
(Missing)	20	0.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5656	1	< 0.1%
6455	1	< 0.1%
6601	1	< 0.1%
6900	1	< 0.1%
7245	1	< 0.1%
7387	1	< 0.1%
7501	1	< 0.1%
7583	1	< 0.1%
7758	1	< 0.1%
8061	1	< 0.1%

Value	Count	Frequency (%)
9320156	1	< 0.1%
1719643	1	< 0.1%
1680937	1	< 0.1%
1639334	1	< 0.1%
1585960	1	< 0.1%
1350182	1	< 0.1%
1314475	1	< 0.1%
1191115	1	< 0.1%
1172127	1	< 0.1%
1072000	1	< 0.1%

SecondLargestPropertyUseType
Categorical

IMBALANCE MISSING

Distinct	50
Distinct (%)	3.0%
Missing	1697
Missing (%)	50.3%
Memory size	26.5 KiB

parking	976
office	215
retail store	155
other	59
restaurant	40
Other values (45)	234

Length

Max length	52
Median length	7
Mean length	9.1774866
Min length	5

Characters and Unicode

Total characters	15409
Distinct characters	31
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	11 ?
Unique (%)	0.7%

Sample

1st row	parking
2nd row	parking
3rd row	parking
4th row	parking
5th row	parking

Common Values

Value	Count	Frequency (%)
parking	976	28.9%
office	215	6.4%
retail store	155	4.6%
other	59	1.7%
restaurant	40	1.2%
non-refrigerated warehouse	33	1.0%
multifamily housing	18	0.5%
fitness center/health club/gym	17	0.5%
supermarket/grocery store	14	0.4%
data center	13	0.4%
Other values (40)	139	4.1%
(Missing)	1697	50.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
parking	976	45.5%
office	228	10.6%
store	170	7.9%
retail	155	7.2%
other	94	4.4%
restaurant	40	1.9%
	37	1.7%
warehouse	35	1.6%
non-refrigerated	33	1.5%
services	20	0.9%
Other values (74)	355	16.6%

Most occurring characters

Value	Count	Frequency (%)
r	1846	12.0%
i	1649	10.7%
a	1507	9.8%
n	1258	8.2%
e	1205	7.8%
g	1093	7.1%
p	1030	6.7%
k	1007	6.5%
t	776	5.0%
o	724	4.7%
Other values (21)	3314	21.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	14751	95.7%
Space Separator	464	3.0%
Other Punctuation	89	0.6%
Dash Punctuation	79	0.5%
Decimal Number	12	0.1%
Open Punctuation	7	< 0.1%
Close Punctuation	7	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	1846	12.5%
i	1649	11.2%
a	1507	10.2%
n	1258	8.5%
e	1205	8.2%
g	1093	7.4%
p	1030	7.0%
k	1007	6.8%
t	776	5.3%
o	724	4.9%
Other values (12)	2656	18.0%

Other Punctuation

Value	Count	Frequency (%)
/	73	82.0%
,	14	15.7%
&	2	2.2%

Decimal Number

Value	Count	Frequency (%)
1	6	50.0%
2	6	50.0%

Space Separator

Value	Count	Frequency (%)
	464	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	79	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	7	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	7	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14751	95.7%
Common	658	4.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	1846	12.5%
i	1649	11.2%
a	1507	10.2%
n	1258	8.5%
e	1205	8.2%
g	1093	7.4%
p	1030	7.0%
k	1007	6.8%
t	776	5.3%
o	724	4.9%
Other values (12)	2656	18.0%

Common

Value	Count	Frequency (%)
	464	70.5%
-	79	12.0%
/	73	11.1%
,	14	2.1%
(	7	1.1%
)	7	1.1%
1	6	0.9%
2	6	0.9%
&	2	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15409	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	1846	12.0%
i	1649	10.7%
a	1507	9.8%
n	1258	8.2%
e	1205	7.8%
g	1093	7.1%
p	1030	6.7%
k	1007	6.5%
t	776	5.0%
o	724	4.7%
Other values (21)	3314	21.5%

SecondLargestPropertyUseTypeGFA
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	1352
Distinct (%)	80.5%
Missing	1697
Missing (%)	50.3%
Infinite	0
Infinite (%)	0.0%
Mean	28444.076

Minimum	0
Maximum	686750
Zeros	126
Zeros (%)	3.7%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5000
median	10664
Q3	26640
95-th percentile	117338.6
Maximum	686750
Range	686750
Interquartile range (IQR)	21640

Descriptive statistics

Standard deviation	54392.918
Coefficient of variation (CV)	1.9122758
Kurtosis	36.302083
Mean	28444.076
Median Absolute Deviation (MAD)	7564
Skewness	5.0334807
Sum	47757603
Variance	2.9585895 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	126	3.7%
5000	14	0.4%
7200	12	0.4%
15000	12	0.4%
6000	12	0.4%
7000	9	0.3%
10000	8	0.2%
8000	7	0.2%
4000	7	0.2%
1500	6	0.2%
Other values (1342)	1466	43.4%
(Missing)	1697	50.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	126	3.7%
2	1	< 0.1%
40	1	< 0.1%
200	1	< 0.1%
220	1	< 0.1%
300	1	< 0.1%
320	1	< 0.1%
363	1	< 0.1%
400	2	0.1%
406	1	< 0.1%

Value	Count	Frequency (%)
686750	1	< 0.1%
639931	1	< 0.1%
441551	1	< 0.1%
438756	1	< 0.1%
389860	1	< 0.1%
387651	1	< 0.1%
380639	1	< 0.1%
377046	1	< 0.1%
348788	1	< 0.1%
340236	1	< 0.1%

ThirdLargestPropertyUseType
Categorical

HIGH CORRELATION MISSING

Distinct	44
Distinct (%)	7.4%
Missing	2780
Missing (%)	82.3%
Memory size	26.5 KiB

retail store	110
office	105
parking	71
restaurant	56
other	49
Other values (39)	205

Length

Max length	52
Median length	27
Mean length	11.996644
Min length	5

Characters and Unicode

Total characters	7150
Distinct characters	30
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	1.5%

Sample

1st row	restaurant
2nd row	swimming pool
3rd row	data center
4th row	swimming pool
5th row	office

Common Values

Value	Count	Frequency (%)
retail store	110	3.3%
office	105	3.1%
parking	71	2.1%
restaurant	56	1.7%
other	49	1.5%
swimming pool	29	0.9%
non-refrigerated warehouse	18	0.5%
medical office	17	0.5%
data center	14	0.4%
multifamily housing	12	0.4%
Other values (34)	115	3.4%
(Missing)	2780	82.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
office	127	13.1%
store	115	11.9%
retail	110	11.3%
other	77	7.9%
parking	71	7.3%
restaurant	59	6.1%
swimming	29	3.0%
pool	29	3.0%
	28	2.9%
warehouse	20	2.1%
Other values (59)	305	31.4%

Most occurring characters

Value	Count	Frequency (%)
e	853	11.9%
r	722	10.1%
t	619	8.7%
i	570	8.0%
a	568	7.9%
o	538	7.5%
	374	5.2%
s	361	5.0%
n	349	4.9%
f	323	4.5%
Other values (20)	1873	26.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6623	92.6%
Space Separator	374	5.2%
Other Punctuation	79	1.1%
Dash Punctuation	58	0.8%
Open Punctuation	6	0.1%
Close Punctuation	6	0.1%
Decimal Number	4	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	853	12.9%
r	722	10.9%
t	619	9.3%
i	570	8.6%
a	568	8.6%
o	538	8.1%
s	361	5.5%
n	349	5.3%
f	323	4.9%
l	308	4.7%
Other values (12)	1412	21.3%

Other Punctuation

Value	Count	Frequency (%)
/	67	84.8%
,	12	15.2%

Decimal Number

Value	Count	Frequency (%)
1	2	50.0%
2	2	50.0%

Space Separator

Value	Count	Frequency (%)
	374	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	58	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	6	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	6	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6623	92.6%
Common	527	7.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	853	12.9%
r	722	10.9%
t	619	9.3%
i	570	8.6%
a	568	8.6%
o	538	8.1%
s	361	5.5%
n	349	5.3%
f	323	4.9%
l	308	4.7%
Other values (12)	1412	21.3%

Common

Value	Count	Frequency (%)
	374	71.0%
/	67	12.7%
-	58	11.0%
,	12	2.3%
(	6	1.1%
)	6	1.1%
1	2	0.4%
2	2	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7150	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	853	11.9%
r	722	10.1%
t	619	8.7%
i	570	8.0%
a	568	7.9%
o	538	7.5%
	374	5.2%
s	361	5.0%
n	349	4.9%
f	323	4.5%
Other values (20)	1873	26.2%

ThirdLargestPropertyUseTypeGFA
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	501
Distinct (%)	84.1%
Missing	2780
Missing (%)	82.3%
Infinite	0
Infinite (%)	0.0%
Mean	11738.675

Minimum	0
Maximum	459748
Zeros	48
Zeros (%)	1.4%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2239
median	5043
Q3	10138.75
95-th percentile	41654.5
Maximum	459748
Range	459748
Interquartile range (IQR)	7899.75

Descriptive statistics

Standard deviation	29331.199
Coefficient of variation (CV)	2.4986805
Kurtosis	114.18711
Mean	11738.675
Median Absolute Deviation (MAD)	3590.5
Skewness	9.1969358
Sum	6996250.4
Variance	8.6031925 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	48	1.4%
6000	7	0.2%
5000	6	0.2%
2000	5	0.1%
3000	5	0.1%
1000	4	0.1%
9000	4	0.1%
6200	3	0.1%
1250	3	0.1%
1500	3	0.1%
Other values (491)	508	15.0%
(Missing)	2780	82.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	48	1.4%
182	1	< 0.1%
187	1	< 0.1%
240	1	< 0.1%
250	1	< 0.1%
285	1	< 0.1%
294	1	< 0.1%
400	1	< 0.1%
404	1	< 0.1%
436	1	< 0.1%

Value	Count	Frequency (%)
459748	1	< 0.1%
303910	1	< 0.1%
220303	1	< 0.1%
177210	1	< 0.1%
141450	1	< 0.1%
133598	1	< 0.1%
103478	1	< 0.1%
103200	1	< 0.1%
88901	1	< 0.1%
84051.89844	1	< 0.1%

YearsENERGYSTARCertified
Real number (ℝ)

Distinct	12
Distinct (%)	10.1%
Missing	3257
Missing (%)	96.5%
Infinite	0
Infinite (%)	0.0%
Mean	3.0588235

Minimum	1
Maximum	15
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	8
Maximum	15
Range	14
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.6112343
Coefficient of variation (CV)	0.85367274
Kurtosis	4.4140338
Mean	3.0588235
Median Absolute Deviation (MAD)	1
Skewness	1.8865609
Sum	364
Variance	6.8185444
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	42	1.2%
2	27	0.8%
3	14	0.4%
4	10	0.3%
5	7	0.2%
7	7	0.2%
6	5	0.1%
9	2	0.1%
8	2	0.1%
10	1	< 0.1%
Other values (2)	2	0.1%
(Missing)	3257	96.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	42	1.2%
2	27	0.8%
3	14	0.4%
4	10	0.3%
5	7	0.2%
6	5	0.1%
7	7	0.2%
8	2	0.1%
9	2	0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
15	1	< 0.1%
13	1	< 0.1%
10	1	< 0.1%
9	2	0.1%
8	2	0.1%
7	7	0.2%
6	5	0.1%
5	7	0.2%
4	10	0.3%
3	14	0.4%

ENERGYSTARScore
Real number (ℝ)

Distinct	100
Distinct (%)	3.9%
Missing	843
Missing (%)	25.0%
Infinite	0
Infinite (%)	0.0%
Mean	67.918674

Minimum	1
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	26.5 KiB

Quantile statistics

Minimum	1
5-th percentile	12
Q1	53
median	75
Q3	90
95-th percentile	99
Maximum	100
Range	99
Interquartile range (IQR)	37

Descriptive statistics

Standard deviation	26.873271
Coefficient of variation (CV)	0.39566837
Kurtosis	-0.21956688
Mean	67.918674
Median Absolute Deviation (MAD)	17
Skewness	-0.85946132
Sum	172038
Variance	722.17269
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	109	3.2%
98	72	2.1%
96	64	1.9%
89	58	1.7%
93	57	1.7%
92	53	1.6%
95	51	1.5%
94	49	1.5%
91	49	1.5%
99	49	1.5%
Other values (90)	1922	56.9%
(Missing)	843	25.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	36	1.1%
2	10	0.3%
3	13	0.4%
4	5	0.1%
5	10	0.3%
6	8	0.2%
7	10	0.3%
8	10	0.3%
9	5	0.1%
10	10	0.3%

Value	Count	Frequency (%)
100	109	3.2%
99	49	1.5%
98	72	2.1%
97	48	1.4%
96	64	1.9%
95	51	1.5%
94	49	1.5%
93	57	1.7%
92	53	1.6%
91	49	1.5%

ComplianceStatus
Categorical

Distinct	4
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	26.5 KiB

compliant	3211
error - correct default data	113
non-compliant	37
missing data	15

Length

Max length	28
Median length	9
Mean length	9.693128
Min length	9

Characters and Unicode

Total characters	32724
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	compliant
2nd row	compliant
3rd row	compliant
4th row	compliant
5th row	compliant

Common Values

Value	Count	Frequency (%)
compliant	3211	95.1%
error - correct default data	113	3.3%
non-compliant	37	1.1%
missing data	15	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
compliant	3211	83.6%
data	128	3.3%
error	113	2.9%
	113	2.9%
correct	113	2.9%
default	113	2.9%
non-compliant	37	1.0%
missing	15	0.4%

Most occurring characters

Value	Count	Frequency (%)
a	3617	11.1%
t	3602	11.0%
o	3511	10.7%
c	3474	10.6%
l	3361	10.3%
n	3337	10.2%
i	3278	10.0%
m	3263	10.0%
p	3248	9.9%
r	565	1.7%
Other values (8)	1468	4.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	32107	98.1%
Space Separator	467	1.4%
Dash Punctuation	150	0.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	3617	11.3%
t	3602	11.2%
o	3511	10.9%
c	3474	10.8%
l	3361	10.5%
n	3337	10.4%
i	3278	10.2%
m	3263	10.2%
p	3248	10.1%
r	565	1.8%
Other values (6)	851	2.7%

Space Separator

Value	Count	Frequency (%)
	467	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	150	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	32107	98.1%
Common	617	1.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	3617	11.3%
t	3602	11.2%
o	3511	10.9%
c	3474	10.8%
l	3361	10.5%
n	3337	10.4%
i	3278	10.2%
m	3263	10.2%
p	3248	10.1%
r	565	1.8%
Other values (6)	851	2.7%

Common

Value	Count	Frequency (%)
	467	75.7%
-	150	24.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	32724	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	3617	11.1%
t	3602	11.0%
o	3511	10.7%
c	3474	10.6%
l	3361	10.3%
n	3337	10.2%
i	3278	10.0%
m	3263	10.0%
p	3248	9.9%
r	565	1.7%
Other values (8)	1468	4.5%

TotalGHGEmissions
Real number (ℝ)

Distinct	2818
Distinct (%)	83.7%
Missing	9
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	119.72397

Minimum	-0.8
Maximum	16870.98
Zeros	9
Zeros (%)	0.3%
Negative	1
Negative (%)	< 0.1%
Memory size	26.5 KiB

Quantile statistics

Minimum	-0.8
5-th percentile	3.78
Q1	9.495
median	33.92
Q3	93.94
95-th percentile	392.797
Maximum	16870.98
Range	16871.78
Interquartile range (IQR)	84.445

Descriptive statistics

Standard deviation	538.83223
Coefficient of variation (CV)	4.5006211
Kurtosis	474.89222
Mean	119.72397
Median Absolute Deviation (MAD)	27.94
Skewness	19.481875
Sum	403110.61
Variance	290340.17
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	9	0.3%
3.95	7	0.2%
4.2	6	0.2%
5.46	6	0.2%
4.74	5	0.1%
5.07	5	0.1%
6.18	5	0.1%
3.63	5	0.1%
4.8	5	0.1%
4.02	5	0.1%
Other values (2808)	3309	98.0%
(Missing)	9	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.8	1	< 0.1%
0	9	0.3%
0.09	1	< 0.1%
0.12	1	< 0.1%
0.17	1	< 0.1%
0.31	1	< 0.1%
0.4	1	< 0.1%
0.5	1	< 0.1%
0.63	1	< 0.1%
0.68	1	< 0.1%

Value	Count	Frequency (%)
16870.98	1	< 0.1%
12307.16	1	< 0.1%
11140.56	1	< 0.1%
10734.57	1	< 0.1%
8145.52	1	< 0.1%
6330.91	1	< 0.1%
4906.33	1	< 0.1%
3995.45	1	< 0.1%
3768.66	1	< 0.1%
3278.11	1	< 0.1%

GHGEmissionsIntensity
Real number (ℝ)

Distinct	511
Distinct (%)	15.2%
Missing	9
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	1.1759162

Minimum	-0.02
Maximum	34.09
Zeros	12
Zeros (%)	0.4%
Negative	1
Negative (%)	< 0.1%
Memory size	26.5 KiB

Quantile statistics

Minimum	-0.02
5-th percentile	0.13
Q1	0.21
median	0.61
Q3	1.37
95-th percentile	3.961
Maximum	34.09
Range	34.11
Interquartile range (IQR)	1.16

Descriptive statistics

Standard deviation	1.8214518
Coefficient of variation (CV)	1.5489639
Kurtosis	57.372156
Mean	1.1759162
Median Absolute Deviation (MAD)	0.44
Skewness	5.5931448
Sum	3959.31
Variance	3.3176866
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.17	99	2.9%
0.15	99	2.9%
0.16	96	2.8%
0.18	86	2.5%
0.19	78	2.3%
0.2	70	2.1%
0.13	66	2.0%
0.14	62	1.8%
0.21	60	1.8%
0.22	54	1.6%
Other values (501)	2597	76.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.02	1	< 0.1%
0	12	0.4%
0.01	4	0.1%
0.02	4	0.1%
0.03	7	0.2%
0.04	9	0.3%
0.05	9	0.3%
0.06	16	0.5%
0.07	8	0.2%
0.08	8	0.2%

Value	Count	Frequency (%)
34.09	1	< 0.1%
25.71	1	< 0.1%
16.99	1	< 0.1%
16.93	1	< 0.1%
16.91	1	< 0.1%
16.38	1	< 0.1%
15.42	1	< 0.1%
14.94	1	< 0.1%
14.89	1	< 0.1%
14.32	1	< 0.1%

Auto

Heatmap
Table

	YearBuilt	NumberofBuildings	NumberofFloors	PropertyGFATotal	PropertyGFAParking	PropertyGFABuilding(s)	LargestPropertyUseTypeGFA	SecondLargestPropertyUseTypeGFA	ThirdLargestPropertyUseTypeGFA	YearsENERGYSTARCertified	ENERGYSTARScore	TotalGHGEmissions	GHGEmissionsIntensity	BuildingType	PrimaryPropertyType	Neighborhood	SecondLargestPropertyUseType	ThirdLargestPropertyUseType	ComplianceStatus
YearBuilt	1.000	0.035	0.292	0.312	0.242	0.283	0.293	0.327	0.098	-0.069	0.075	0.027	-0.196	0.158	0.186	0.176	0.191	0.126	0.059
NumberofBuildings	0.035	1.000	-0.023	0.069	0.006	0.068	0.083	0.025	0.004	-0.083	0.037	0.049	0.016	0.240	0.136	0.014	0.181	0.964	0.000
NumberofFloors	0.292	-0.023	1.000	0.440	0.262	0.431	0.414	0.435	0.212	0.494	0.118	0.175	-0.102	0.262	0.276	0.140	0.000	0.027	0.000
PropertyGFATotal	0.312	0.069	0.440	1.000	0.345	0.983	0.929	0.682	0.480	0.485	0.074	0.579	0.068	0.144	0.173	0.057	0.000	0.105	0.000
PropertyGFAParking	0.242	0.006	0.262	0.345	1.000	0.221	0.273	0.372	0.266	0.468	0.010	0.208	-0.009	0.052	0.155	0.058	0.000	0.000	0.000
PropertyGFABuilding(s)	0.283	0.068	0.431	0.983	0.221	1.000	0.927	0.644	0.452	0.403	0.074	0.574	0.074	0.166	0.190	0.047	0.000	0.000	0.000
LargestPropertyUseTypeGFA	0.293	0.083	0.414	0.929	0.273	0.927	1.000	0.565	0.346	0.435	0.085	0.565	0.088	0.148	0.226	0.047	0.000	0.000	0.000
SecondLargestPropertyUseTypeGFA	0.327	0.025	0.435	0.682	0.372	0.644	0.565	1.000	0.609	0.435	0.179	0.415	-0.004	0.124	0.235	0.057	0.034	0.177	0.079
ThirdLargestPropertyUseTypeGFA	0.098	0.004	0.212	0.480	0.266	0.452	0.346	0.609	1.000	0.338	0.119	0.353	0.015	0.178	0.000	0.000	0.177	0.122	0.000
YearsENERGYSTARCertified	-0.069	-0.083	0.494	0.485	0.468	0.403	0.435	0.435	0.338	1.000	0.189	0.274	-0.295	0.000	0.000	0.000	0.000	0.000	0.000
ENERGYSTARScore	0.075	0.037	0.118	0.074	0.010	0.074	0.085	0.179	0.119	0.189	1.000	-0.118	-0.237	0.115	0.118	0.054	0.063	0.139	0.120
TotalGHGEmissions	0.027	0.049	0.175	0.579	0.208	0.574	0.565	0.415	0.353	0.274	-0.118	1.000	0.824	0.126	0.259	0.000	0.000	0.358	0.000
GHGEmissionsIntensity	-0.196	0.016	-0.102	0.068	-0.009	0.074	0.088	-0.004	0.015	-0.295	-0.237	0.824	1.000	0.126	0.268	0.000	0.161	0.118	0.008
BuildingType	0.158	0.240	0.262	0.144	0.052	0.166	0.148	0.124	0.178	0.000	0.115	0.126	0.126	1.000	0.732	0.203	0.315	0.222	0.451
PrimaryPropertyType	0.186	0.136	0.276	0.173	0.155	0.190	0.226	0.235	0.000	0.000	0.118	0.259	0.268	0.732	1.000	0.234	0.211	0.239	0.381
Neighborhood	0.176	0.014	0.140	0.057	0.058	0.047	0.047	0.057	0.000	0.000	0.054	0.000	0.000	0.203	0.234	1.000	0.152	0.000	0.098
SecondLargestPropertyUseType	0.191	0.181	0.000	0.000	0.000	0.000	0.000	0.034	0.177	0.000	0.063	0.000	0.161	0.315	0.211	0.152	1.000	0.175	0.156
ThirdLargestPropertyUseType	0.126	0.964	0.027	0.105	0.000	0.000	0.000	0.177	0.122	0.000	0.139	0.358	0.118	0.222	0.239	0.000	0.175	1.000	0.000
ComplianceStatus	0.059	0.000	0.000	0.000	0.000	0.000	0.000	0.079	0.000	0.000	0.120	0.000	0.008	0.451	0.381	0.098	0.156	0.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	BuildingType	PrimaryPropertyType	Neighborhood	YearBuilt	NumberofBuildings	NumberofFloors	PropertyGFATotal	PropertyGFAParking	PropertyGFABuilding(s)	ListOfAllPropertyUseTypes	LargestPropertyUseType	LargestPropertyUseTypeGFA	SecondLargestPropertyUseType	SecondLargestPropertyUseTypeGFA	ThirdLargestPropertyUseType	ThirdLargestPropertyUseTypeGFA	YearsENERGYSTARCertified	ENERGYSTARScore	ComplianceStatus	TotalGHGEmissions	GHGEmissionsIntensity
0	nonresidential	hotel	downtown	1927	1.0	12	88434	0	88434	hotel	hotel	88434.0	NaN	NaN	NaN	NaN	NaN	60.0	compliant	249.98	2.83
1	nonresidential	hotel	downtown	1996	1.0	11	103566	15064	88502	hotel, parking, restaurant	hotel	83880.0	parking	15064.0	restaurant	4622.0	NaN	61.0	compliant	295.86	2.86
2	nonresidential	hotel	downtown	1969	1.0	41	956110	196718	759392	hotel	hotel	756493.0	NaN	NaN	NaN	NaN	NaN	43.0	compliant	2089.28	2.19
3	nonresidential	hotel	downtown	1926	1.0	10	61320	0	61320	hotel	hotel	61320.0	NaN	NaN	NaN	NaN	NaN	56.0	compliant	286.43	4.67
4	nonresidential	hotel	downtown	1980	1.0	18	175580	62000	113580	hotel, parking, swimming pool	hotel	123445.0	parking	68009.0	swimming pool	0.0	NaN	75.0	compliant	505.01	2.88
5	nonresidential cos	other	downtown	1999	1.0	2	97288	37198	60090	police station	police station	88830.0	NaN	NaN	NaN	NaN	NaN	NaN	compliant	301.81	3.10
6	nonresidential	hotel	downtown	1926	1.0	11	83008	0	83008	hotel	hotel	81352.0	NaN	NaN	NaN	NaN	NaN	27.0	compliant	176.14	2.12
7	nonresidential	other	downtown	1926	1.0	8	102761	0	102761	other - entertainment/public assembly	other - entertainment/public assembly	102761.0	NaN	NaN	NaN	NaN	NaN	NaN	compliant	221.51	2.16
8	nonresidential	hotel	downtown	1904	1.0	15	163984	0	163984	hotel	hotel	163984.0	NaN	NaN	NaN	NaN	NaN	43.0	compliant	392.16	2.39
9	multifamily mr (5-9)	mid-rise multifamily	downtown	1910	1.0	6	63712	1496	62216	multifamily housing	multifamily housing	56132.0	NaN	NaN	NaN	NaN	NaN	1.0	compliant	151.12	2.37

	BuildingType	PrimaryPropertyType	Neighborhood	YearBuilt	NumberofBuildings	NumberofFloors	PropertyGFATotal	PropertyGFABuilding(s)	ListOfAllPropertyUseTypes	LargestPropertyUseType	LargestPropertyUseTypeGFA	SecondLargestPropertyUseType	SecondLargestPropertyUseTypeGFA	ThirdLargestPropertyUseType	ThirdLargestPropertyUseTypeGFA	YearsENERGYSTARCertified	ENERGYSTARScore	ComplianceStatus	TotalGHGEmissions	GHGEmissionsIntensity
3366	nonresidential cos	office	magnolia / queen anne	1952	1.0	1	13661	13661	office	office	13661.0	NaN	NaN	NaN	NaN	NaN	75.0	error - correct default data	3.50	0.26
3367	nonresidential cos	other	east	1912	1.0	1	23445	23445	other - recreation	other - recreation	23445.0	NaN	NaN	NaN	NaN	NaN	NaN	compliant	259.22	11.06
3368	nonresidential cos	mixed use property	central	1994	1.0	1	20050	20050	fitness center/health club/gym, office, other - recreation, other - technology/science	other - recreation	8108.0	fitness center/health club/gym	7726.0	office	3779.0	NaN	NaN	compliant	60.81	3.03
3369	nonresidential cos	office	southeast	1960	1.0	1	15398	15398	office	office	15398.0	NaN	NaN	NaN	NaN	NaN	93.0	error - correct default data	7.79	0.51
3370	nonresidential cos	other	delridge neighborhoods	1982	1.0	1	18261	18261	other - recreation	other - recreation	18261.0	NaN	NaN	NaN	NaN	NaN	NaN	compliant	20.33	1.11
3371	nonresidential cos	office	greater duwamish	1990	1.0	1	12294	12294	office	office	12294.0	NaN	NaN	NaN	NaN	NaN	46.0	error - correct default data	20.94	1.70
3372	nonresidential cos	other	downtown	2004	1.0	1	16000	16000	other - recreation	other - recreation	16000.0	NaN	NaN	NaN	NaN	NaN	NaN	compliant	32.17	2.01
3373	nonresidential cos	other	magnolia / queen anne	1974	1.0	1	13157	13157	fitness center/health club/gym, other - recreation, swimming pool	other - recreation	7583.0	fitness center/health club/gym	5574.0	swimming pool	0.0	NaN	NaN	compliant	223.54	16.99
3374	nonresidential cos	mixed use property	greater duwamish	1989	1.0	1	14101	14101	fitness center/health club/gym, food service, office, other - recreation, pre-school/daycare	other - recreation	6601.0	fitness center/health club/gym	6501.0	pre-school/daycare	484.0	NaN	NaN	compliant	22.11	1.57
3375	nonresidential cos	mixed use property	greater duwamish	1938	1.0	1	18258	18258	fitness center/health club/gym, food service, office, other - recreation, pre-school/daycare	other - recreation	8271.0	fitness center/health club/gym	8000.0	pre-school/daycare	1108.0	NaN	NaN	compliant	41.27	2.26

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Space Separator

Dash Punctuation

Close Punctuation

Open Punctuation

Math Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Space Separator

Dash Punctuation

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Other Punctuation

Decimal Number

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Other Punctuation

Decimal Number

Space Separator

Dash Punctuation

Open Punctuation